| AdIPEDSDistEdCriteriaDetail |
| EntityType | Independent |
| Logical Entity Name | AdIPEDSDistEdCriteriaDetail |
| Default Table Name | AdIPEDSDistEdCriteriaDetail |
| Logical Only | NO |
| Definition | |
| Note |
| AdIPEDSDistEdCriteriaDetail Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
AdIPEDSDistEdCriteriaDetailId |
CHAR(10) | NO | ||
AdIPEDSDistEdCriteriaID |
CHAR(10) | NO | ||
EnrollCampusID |
INTEGER | YES | ||
CourseRegCampusID |
INTEGER | YES | ||
DeliveryMethodId |
INTEGER | YES | ||
CourseTypeId |
INTEGER | YES | ||
EnrollShiftID |
INTEGER | YES | ||
CourseShiftID |
INTEGER | YES | ||
ProgramId |
INTEGER | YES | ||
ProgramVersionId |
INTEGER | YES | ||
ExtraCurricularActivityId |
INTEGER | YES | ||
UserId |
INTEGER | NO | ||
| DateAdded | CHAR(10) | NO | ||
| DateLstMod | CHAR(10) | NO | ||
| ts | CHAR(10) | NO |
| AdIPEDSDistEdCriteriaDetail Keys |
| Key Name | Key Type | Keys |
| Pk_AdIPEDSDistEdCriteriaDetail_AdIPEDSDistEdCriteriaDetailId | PrimaryKey | AdIPEDSDistEdCriteriaDetailId |
| NK_AdIPEDSDistEdCriteriaDetail_AdIPEDSDistEdCriteriaID | Inversion Entry | AdIPEDSDistEdCriteriaID |
| NK_AdIPEDSDistEdCriteriaDetail_EnrollCampusID | Inversion Entry | EnrollCampusID |
| NK_AdIPEDSDistEdCriteriaDetail_CourseRegCampusID | Inversion Entry | CourseRegCampusID |
| NK_AdIPEDSDistEdCriteriaDetail_AdDeliveryMethodID | Inversion Entry | DeliveryMethodId |
| NK_AdIPEDSDistEdCriteriaDetail_AdCourseTypeID | Inversion Entry | CourseTypeId |
| NK_AdIPEDSDistEdCriteriaDetail_EnrollShiftID | Inversion Entry | EnrollShiftID |
| NK_AdIPEDSDistEdCriteriaDetail_CourseShiftID | Inversion Entry | CourseShiftID |
| NK_AdIPEDSDistEdCriteriaDetail_AdProgramID | Inversion Entry | ProgramId |
| NK_AdIPEDSDistEdCriteriaDetail_AdProgramVersionID | Inversion Entry | ProgramVersionId |
| NK_AdIPEDSDistEdCriteriaDetail_AmExtraCurrID | Inversion Entry | ExtraCurricularActivityId |
| AdIPEDSDistEdCriteriaDetail Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| CourseType | Non-Identifying | Zero or One to Zero or More | CourseTypeId | NO | |||
| DeliveryMethod | Non-Identifying | Zero or One to Zero or More | DeliveryMethodId | NO | |||
| AdIPEDSDistEdCriteria | Non-Identifying | One To Zero or More | AdIPEDSDistEdCriteriaID | NO | |||
| Program | Non-Identifying | Zero or One to Zero or More | ProgramId | NO | |||
| ProgramVersion | Non-Identifying | Zero or One to Zero or More | ProgramVersionId | NO | |||
| ExtraCurricularActivity | Non-Identifying | Zero or One to Zero or More | ExtraCurricularActivityId | NO | |||
| Campus | Non-Identifying | Zero or One to Zero or More | CourseRegCampusID | NO | |||
| Shift | Non-Identifying | Zero or One to Zero or More | CourseShiftID | NO | |||
| Campus | Non-Identifying | Zero or One to Zero or More | EnrollCampusID | NO | |||
| Shift | Non-Identifying | Zero or One to Zero or More | EnrollShiftID | NO | |||
| Staff | Non-Identifying | One To Zero or More | UserId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| AdIPEDSDistEdCriteriaDetail Check Constraints |
| Check Constraint Name | CheckConstraint |